SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_UpdateFile
    @FileId					int,
    @VersionGuid			uniqueidentifier,	
    @FileName				nvarchar(246),
    @Extension				nvarchar(100),
    @Size					int,
    @Width					int,
    @Height					int,
    @ContentType			nvarchar(200),	
    @Folder					nvarchar(246),
    @FolderID				int,
	@LastModifiedByUserID  	int,
	@Hash					varchar(40),
	@LastModificationTime	DATETIME
AS
    UPDATE dbo.DnnProduct_Files
        SET    FileName = @FileName,
               VersionGuid = @VersionGuid,
               Extension = @Extension,
               Size = @Size,
               Width = @Width,
               Height = @Height,
               ContentType = @ContentType,
               Folder = @Folder,
               FolderID = @FolderID,
               LastModifiedByUserID = @LastModifiedByUserID,
               LastModifiedOnDate = getdate(),
			   SHA1Hash = @Hash,
			   LastModificationTime = @LastModificationTime
    WHERE  FileId = @FileId

GO
